CREATE TABLE [dbo].[leerlingen] (
	[inschrijvingsNr] [char] (7) NOT NULL ,
	[stamNr] [char] (7) NULL ,
	[achternaam] [varchar] (50) NULL ,
	[voornaam] [varchar] (50) NULL ,
	[naam1] [varchar] (50) NULL ,
	[klas] [varchar] (5) NULL ,
	[klasNr] [int] NULL ,
	[schoolNummer] [varchar] (6) NULL ,
	CONSTRAINT [pk_deLeerling] PRIMARY KEY  NONCLUSTERED 
	(
		[inschrijvingsNr]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] ,
	 UNIQUE  NONCLUSTERED 
	(
		[inschrijvingsNr]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
) ON [PRIMARY]
 CREATE  INDEX [id_inschrijvingsNr] ON [dbo].[leerlingen]([inschrijvingsNr]) WITH  FILLFACTOR = 90 ON [PRIMARY]
 CREATE  INDEX [ klasindex] ON [dbo].[leerlingen]([klas], [klasNr]) ON [PRIMARY]